Relatamail Data Dictionary


This document provides Relatamail users with a list of the table fields, which have been used in the Relatamail database. For each table field, a brief description is provided.
 
Table: BlastLOG
The table ‘BlastLOG’ records information about each ‘bulk email send out’, also known as a ‘blast’.

Field

Type

Null

MsgOwner

Int(11)

No

MsgNumber

Int(11)

No

RecipientCount

bigint(20)

No

EmailFrom

varchar(80)

No

NameFrom

varchar(80)

No

MsgSubject

longtext

No

MsgDescription

longtext

No

DestinationSite

varchar(80)

No

RedirectURL

longtext

No

AOLRedirectURL

longtext

No

UnsubscribeURL

longtext

No

AOLUnsubscribeURL

longtext

No

UnsubscribePrompt

longtext

No

AOLAware

enum('0','1')

No

AppendVar

longtext

No

MsgTemplate

longtext

No

SendOutBeganAt

datetime

No

SendOutCompletedAt

datetime

No

SendOutCancelled

enum('0','1')

No

Keyname

Unique

Field

PRIMARY

Yes

MsgOwner

PRIMARY

Yes

MsgNumber

 Fields:

  1. MsgOwner
  2. Data Type: Integer

    Definition: the owner of the message being sent.

    Example: 1

    Properties: numeric, size: 11

    Entered By: system

    Type of Key: primary

    Required: yes 

  3. MsgNumber
  4. Data Type: Integer

    Definition: the number of the message being sent.

    Example: 110

    Properties: numeric, size: 11

    Entered By: system

    Type of Key: primary

    Required: yes

  5. RecipientCount
  6. Data Type: Big Integer

    Definition: the number of recipients the message is being sent to.

    Example: 1000

    Properties: numeric, size: 20

    Entered By: system

    Type of Key: non-primary

    Required: yes 

  7. EmailFrom
  8. Data Type: Alphanumeric

    Definition: the senders email address

    Example: avinesh@stratabase.com

    Properties: Alphanumeric, size: 80

    Entered By: system

    Type of Key: non-primary

    Required: yes 

  9. NameFrom
  10. Data Type: Alphanumeric

    Definition: the senders email address

    Example: Avinesh Bangar

    Properties: Alphanumeric, size: 80

    Entered By: system

    Type of Key: non-primary

    Required: yes

     

  11. MsgSubject
  12. Data Type: Alphanumeric

    Definition: the subject of the email

    Example: PalmUsers Group Vol. 1

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes 

     

  13. MsgDescription
  14. Data Type: Alphanumeric

    Definition: description of the message being sent

    Example: First sendout to Palm users subscribed to list

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes 

     

  15. DestinationSite
  16. Data Type: Alphanumeric

    Definition: the destination URL the receiver can click on.

    Example: http://www.blah.com/blah.php?email=avinesh@stratabase.com

    Properties: Alphanumeric, size: 80

    Entered By: system

    Type of Key: non-primary

    Required: yes 

     

  17. RedirectURL
  18. Data Type: Alphanumeric

    Definition: the URL where the user will be redirected to when the destination site has been contacted.

    Example: http://www.stratabase.com

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes 

     

     

  19. AOLRedirectURL
  20. Data Type: Alphanumeric

    Definition: the URL where AOL users will be redirected to when the destination site has been contacted.

    Example: http://www.stratabase.com

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes

     

  21. UnsubscribeURL
  22. Data Type: Alphanumeric

    Definition: the URL the receiver can click on to unsubscribe from a list.

    Example: http://www.blah.com/unsubscribe.php?email=avinesh@stratabase.com

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes

  23. AOLUnsubscribeURL
  24. Data Type: Alphanumeric

    Definition: the URL an AOL user can click on to unsubscribe from a list.

    Example: http://www.blah.com/unsubscribe.php?email=someguy@aol.com

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes 

  25. UnsubscribePrompt
  26. Data Type: Alphanumeric

    Definition: the message sent to the user when unsubscribing from a list.

    Example: Are you sure you want to unsubscribe from this list?

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes

     

     

  27. AOLAware
  28. Data Type: Boolean

    Definition: select 1 if sending out to AOL users.

    Example: 1

    Properties: Enumeration, size: 1; 0 or 1

    Entered By: system

    Type of Key: non-primary

    Required: yes 

  29. AppendVar
  30. Data Type: Alphanumeric

    Definition: a variable to append to the end of an URL

    Example: email

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes 

  31. MsgTemplate
  32. Data Type: Alphanumeric

    Definition: the core body of the message

    Example: Dear user, Welcome to the Palm Users Mailing List!

    Properties: Alphanumeric, size: 4.3 billion

    Entered By: system

    Type of Key: non-primary

    Required: yes 

  33. SendOutBeganAt
  34. Data Type: datetime

    Definition: the date and time the sent out began at

    Example: 2000-10-17 11:51:41

    Properties: Datetime, size: default

    Entered By: system

    Type of Key: non-primary

    Required: yes

     

  35. SendOutCompletedAt

Data Type: datetime

Definition: the date and time the send out completed

Example: 2000-10-17 11:54:41

Properties: Datetime, size: default

Entered By: system

Type of Key: non-primary

Required: yes

 

19. SendOutCancelled

Data Type: Boolean

Definition: whether the send out was cancelled.

Example: 1

Properties: Alphanumeric, size: 80

Entered By: system

Type of Key: non-primary

Required: yes

Table: Contact

The table ‘Contact’ records information about each contact person.

Field

Type

Null

Email

Varchar(80)

No

First_Name

Varchar(40)

No

Last_Name

Varchar(40)

No

Address

Varchar(60)

No

City

Varchar(40)

No

State

varchar(20)

No

Zip

varchar(20)

No

Country

varchar(40)

No

Phone1

varchar(30)

No

Phone2

varchar(30)

No

Fax

varchar(30)

No

Language

varchar(30)

No

Birthdate

varchar(20)

No

Sex

char(1)

No

Married

char(1)

No

Employed

char(1)

No

Email_Type

char(1)

No

Entry_Date

date

No

Undeliverable_Count

int(11)

No

     

Keyname

Unique

Field

PRIMARY

Yes

Email

email

No

Email

 

Fields
  1. Email
  2. Data Type: Alphanumeric

    Definition: the unique email address of the person. Each person has an unique email address that is uniquely theirs, it identifies them.

    Example: avinesh@stratabase.com

    Properties: alphanumeric, size: 80

    Entered By: user

    Type of Key: primary

    Required: yes

     

  3. First_Name
  4. Data Type: Alphanumeric

    Definition: the first name of the person

    Example: Avinesh

    Properties: Alphanumeric, size: 40

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  5. Last_Name
  6. Data Type: Alphanumeric

    Definition: the last name of the person

    Example: Bangar

    Properties: Alphanumeric, size: 40

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  7. Address
  8. Data Type: Alphanumeric

    Definition: the street address where the person lives

    Example: 12345 Any Street

    Properties: Alphanumeric, size: 60

    Entered By: user

    Type of Key: non-primary

    Required: no 

     

  9. City
  10. Data Type: Alphanumeric

    Definition: the city where the person lives

    Example: Abbotsford

    Properties: Alphanumeric, size: 40

    Entered By: user

    Type of Key: non-primary

    Required: no 

  11. State
  12. Data Type: Alphanumeric

    Definition: the state or province where the person lives

    Example: Avinesh

    Properties: Alphanumeric, size: 20

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  13. Zip
  14. Data Type: Alphanumeric

    Definition: the zip or postal code where the person lives first name of the person

    Example: 12345

    Properties: Alphanumeric, size: 20

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  15. Country
  16. Data Type: Alphanumeric

    Definition: the country where the person lives

    Example: CANADA

    Properties: Alphanumeric, size: 40

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  17. Phone1
  18. Data Type: Alphanumeric

    Definition: the primary phone number of the person

    Example: 123-4567

    Properties: Alphanumeric, size: 30

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  19. Phone2
  20. Data Type: Alphanumeric

    Definition: the secondary phone number of the person

    Example: 123-4567

    Properties: Alphanumeric, size: 30

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  21. Fax
  22. Data Type: Alphanumeric

    Definition: the fax number of the person

    Example: 123-4567

    Properties: Alphanumeric, size: 30

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  23. Language
  24. Data Type: Alphanumeric

    Definition: the preferred language of the person

    Example: English

    Properties: Alphanumeric, size: 30

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  25. Birthdate
  26. Data Type: Alphanumeric

    Definition: the birthdate of the person

    Example: 01-01-01

    Properties: Alphanumeric, size: 20

    Entered By: user

    Type of Key: non-primary

    Required: no 

  27. Sex
  28. Data Type: Alpha

    Definition: person is either male (M) or female (F)

    Example: M

    Properties: Alpha, size: 1

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  29. Married
  30. Data Type: Alpha

    Definition: person is either single (S) or married (M)

    Example: S

    Properties: Alpha, size: 1

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  31. Employed
  32. Data Type: Alpha

    Definition: person is either employed (E) or unemployed (U) or retired (R)

    Example: E

    Properties: Alpha, size: 1

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  33. Email_Type
  34. Data Type: Alpha

    Definition: the email type used by the person – either HTML or Text

    Example: H (H or T)

    Properties: Alpha, size: 1

    Entered By: system

    Type of Key: non-primary

    Required: no 

  35. Entry_Date
  36. Data Type: Numeric (Date)

    Definition: the date the person was first entered into our database

    Example: MM/DD/YYYY

    Properties: Numeric, size: 10

    Entered By: system

    Type of Key: non-primary

    Required: no 

  37. Undeliverable_Count

Data Type: Numeric

Definition: the number of times an undeliverable email was sent to this person

Example: 2

Properties: Numeric, size: 1

Entered By: system

Type of Key: non-primary

Required: no

 

Table: Contact_List
The table ‘Contact_List’ records the list(s) that each contact (in the ‘Contact’ table) is subscribed too.

Field

Type

Null

Email

varchar(80)

No

List_Number

int(10)

No

Subscribe_Date

date

Yes

Unsubscribe_Date

date

Yes

Keyname

Unique

Field

PRIMARY

Yes

Email

PRIMARY

Yes

List_Number

 

Fields:

  1. Email
  2. Data Type: Alphanumeric

    Definition: the email address of the person

    Example: avinesh@stratabase.com

    Properties: Alphanumeric, size: 80

    Entered By: user

    Type of Key: primary

    Required: yes 

     

  3. List_Number
  4. Data Type: Numeric

    Definition: the list number the person is subscribed to

    Example: 1

    Properties: numeric, size: 10

    Entered By: user

    Type of Key: non-primary

    Required: no 

     

  5. Subscribe_Date
  6. Data Type: Date format (numeric)

    Definition: the date the person signed up (subscribed) to the list they are subscribed to

    Example: MM/DD/YYYY

    Properties: numeric, size: 20

    Entered By: system

    Type of Key: non-primary

    Required: no

     

  7. Unsubscribe_Date

Data Type: Date format (numeric)

Definition: the date the person unsubscribed from the list they originally subscribed to.

Example: MM/DD/YYYY

Properties: numeric, size: 20

Entered By: system

Type of Key: non-primary

Required: no

 

Table: Contact_Message
The table ‘Contact_Message’ records the messages that each subscriber has received.

Field

Type

Null

Default

Email

varchar(80)

No

 

Message_Number

int(10)

No

0

TimeDate_Sent

datetime

No

0000-00-00 00:00:00

TimeDate_Click

datetime

No

0000-00-00 00:00:00

TimeDate_Undeliverable

datetime

No

0000-00-00 00:00:00

DestinationURL

varchar(80)

No

 

AppendVar

varchar(80)

No

n

Keyname

Unique

Field

PRIMARY

Yes

Email

PRIMARY

Yes

Message_Number

PRIMARY

Yes

Email

 

Fields:

  1. Email
  2. Data Type: Alphanumeric

    Definition: email address of the receiver

    Example: avinesh@stratabase.com

    Properties: Alphanumeric, size: 80

    Entered By: system

    Type of Key: primary

    Required: yes

     

     

  3. Message_Number
  4. Data Type: Numeric

    Definition: message number

    Example: 1

    Properties: numeric, size: 10

    Entered By: system

    Type of Key: primary

    Required: no

     

     

  5. TimeDate_Sent
  6. Data Type: Date format (numeric)

    Definition: the date the person sent the message

    Example: MM/DD/YYYY 00:00:00

    Properties: numeric, size: 20

    Entered By: system

    Type of Key: non-primary

    Required: no

  7. TimeDate_Undeliverable
  8. Data Type: Date format (numeric)

    Definition: the date the

    Example: MM/DD/YYYY 00:00:00

    Properties: numeric, size: 20

    Entered By: system

    Type of Key: non-primary

    Required: no

     

  9. DestinationURL
  10. Data Type: Alphanumeric

    Definition: the URL the receiver of the email clicked on

    Example: http://www.myhost.com/mypage.htm?user=bob&id=1234

    Properties: numeric, size: 80

    Entered By: system

    Type of Key: non-primary

    Required: no

     

  11. AppendVar

Data Type: Alphanumeric

Definition: the variable name appended to the end of the URL string

Example: ?email=user@host.com

Properties: alphanumeric, size: 80

Entered By: user

Type of Key: non-primary

Required: no

 

Table: List

The table ‘List’ records information about each list.

Field

Type

Attributes

Null

Default

Number

int(10)

 

No

0

Name

Varchar(40)

 

No

 

Description

Varchar(200)

 

No

 

Source

Varchar(100)

 

No

 

Owner

int(11)

 

No

 

Keyname

Unique

Field

PRIMARY

Yes

Number

 

Fields:

  1. Number
  2. Data Type: Numeric

    Definition: the number we have assigned to the list which people subscribe to, the list number is the unique code we use to describe the individual list.

    Example: 1

    Properties: numeric, size: 10

    Entered By: system

    Type of Key: primary

    Required: yes

     

  3. Name
  4. Data Type: Alphanumeric

    Definition: the name of the list that people have subscribed to

    Example: Bob’s List

    Properties: Alphanumeric, size: 10

    Entered By: user

    Type of Key: non-primary

    Required: yes

     

  5. Description
  6. Data Type: Alphanumeric

    Definition: descriptive phrase that tells which subject matter the list covers

    Example: Bob’s List

    Properties: Alphanumeric, size: 200

    Entered By: user

    Type of Key: non-primary

    Required: no 

     

  7. Source
  8. Data Type: Alphanumeric

    Definition: a short description of the list owner

    Example: John Smith

    Properties: Alphanumeric, size: 100

    Entered By: user

    Type of Key: non-primary

    Required: no 

      

  9. Owner

Data Type: Numeric

Definition: the number of the owner of the list, cross-references with RM_User::UserNumber

Example: 1001

Properties: numeric, size: 11

Entered By: system

Type of Key: non-primary

Required: no

Table: Message

The table ‘Message’ records information about each email message that has been sent out to subscribers.

Field

Type

Attributes

Null

Default

Number

int(10)

 

No

0

Description

varchar(200)

 

No

 

DateSent

date

 

No

 

List_Number

int(11)

 

No

0

Msg_Type

enum(‘test’, blast’)

 

No

test

Keyname

Unique

Field

PRIMARY

Yes

Number

PRIMARY

Yes

List_Number

 Fields:

  1. Number
  2. Data Type: Numeric

    Definition: the number we assign through our system to the message which gets sent to the subscriber.

    Example: 1001

    Properties: Numeric, size: 10

    Entered By: system

    Type of Key: primary

    Required: yes 

  3. Description
  4. Data Type: Alphanumeric

    Definition: the description of the message sent to the recipients, inputted by the sender to describe its contents.

    Example: A test email

    Properties: Alphanumeric, size: 200

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  5. DateSent
  6. Data Type: Date

    Definition: the date the message was sent

    Example: 2001-01-01

    Properties: Date, size: 10

    Entered By: system

    Type of Key: non-primary

    Required: no

     

     

  7. List_Number
  8. Data Type: Numeric

    Definition: the list the message was sent out to

    Example: 101

    Properties: Numeric, size: 11

    Entered By: system

    Type of Key: non-primary

    Required: no

     

  9. Msg_Type

Data Type: Boolean

Definition: the type of message being sent, either test or blast

Example: blast

Properties: Enum, size: 5

Entered By: user

Type of Key: non-primary

Required: no

Table: RMUser

The table ‘RM_User’ records information about each registered Relatamail user.

Field

Type

Null

Default

Email

varchar(80)

No

 

First_Name

varchar(80)

No

 

Last_Name

varchar(80)

No

 

TimeDate_Register

datetime

No

0000-00-00 00:00:00

Login

varchar(80)

No

 

Password

varchar(80)

No

 

User_Number

int(11)

No

0

DateTime_Login

datetime

No

0000-00-00 00:00:00

DateTime_Logout

datetime

No

0000-00-00 00:00:00

IP

varchar(80)

No

 

Session_Key

varchar(80)

No

 

RM_Access

enum('1','0')

No

1

UserID

Longtext

No

 

 

Keyname

Unique

Field

Action

PRIMARY

Yes

Email

Drop

 Fields:

  1. Email
  2. Data Type: Alphanumeric

    Definition: email address of the user

    Example: ravi@stratabase.com

    Properties: alphanumeric, size: 80

    Entered By: user

    Type of Key: primary

    Required: yes 

  3. First_Name
  4. Data Type: Alphanumeric

    Definition: this is the first name of the user

    Example: Ravi

    Properties: alphanumeric, size: 80

    Entered By: user

    Type of Key: non-primary

    Required: yes 

  5. Last_Name
  6. Data Type: Alphanumeric

    Definition: this is the last name of the user

    Example: Gill

    Properties: alphanumeric, size: 80

    Entered By: user

    Type of Key: non-primary

    Required: yes 

  7. TimeDate_Register
  8. Data Type: Date

    Definition: this is the time and date the user registered

    Example: 2000-01-01 00:00:00

    Properties: Numeric, size: 12

    Entered By: user

    Type of Key: non-primary

    Required: yes

     

  9. Login
  10. Data Type: Alphanumeric

    Definition: this is the login of the user

    Example: Bob2000

    Properties: Alphanumeric, size: 80

    Entered By: user

    Type of Key: non-primary

    Required: yes

     

  11. Password
  12. Data Type: Alphanumeric

    Definition: this is the password of the user

    Example: R3latama1l

    Properties: alphanumeric, size: 80

    Entered By: user

    Type of Key: non-primary

    Required: yes

     

     

  13. User_Number
  14. Data Type: Numeric

    Definition: this is the user number of the user

    Example: 1

    Properties: alphanumeric, size: 11

    Entered By: system

    Type of Key: non-primary

    Required: yes 

  15. DateTime_Login
  16. Data Type: Date

    Definition: the date and time a user logged in into the Relatamail system

    Example: 2000-01-01 00:00:00

    Properties: Numeric, size: 12

    Entered By: system

    Type of Key: non-primary

    Required: yes 

  17. DateTime_Logout
  18. Data Type: Date

    Definition: this is when the user logged out from the Relatamail system

    Example: 2000-01-01 00:00:04

    Properties: Numeric, size: 12

    Entered By: system

    Type of Key: non-primary

    Required: yes

     

     

     

     

  19. IP
  20. Data Type: Alphanumeric

    Definition: this is the Internet Protocol (IP) address of the user

    Example: 123.456.789.100

    Properties: Alphanumeric, size: 80

    Entered By: system

    Type of Key: non-primary

    Required: yes

     

  21. Session_Key
  22. Data Type: Alphanumeric

    Definition: this is the session key of the user, dynamic

    Example: f1f2f3f4g5f65f6f7f8f8f9f0

    Properties: Alphanumeric, size: 80

    Entered By: system

    Type of Key: non-primary

    Required: yes

     

  23. RM_Access
  24. Data Type: Numeric

    Definition: determines if the user has permission to use the Relatamail system

    Example: 1

    Properties: enum, size: 1

    Entered By: system

    Type of Key: non-primary

    Required: yes

     

     

  25. UserID

Data Type: Longtext

Definition: the user ID of the current user, dynamic

Example: s42f82f28f208f10f1

Properties: longtext, size: ~4.3 billion

Entered By: system

Type of Key: non-primary

Required: yes

 

 

Table: session_#

The table ‘session_#’ is a session table. One session table is created for each registered Relatamail user. The ‘#’ is replaced with the user’s ‘user number’ (eg. user number = 1, session_1). The session tables record users’ session variables during their course of Relatamail use.

Field

Type

Null

Name

Varchar(80)

No

Value

Longtext

No

Keyname

Unique

Field

PRIMARY

Yes

Name

Fields:

  1. Name
  2. Data type: Alphanumeric

    Definition: the name of the variable

    Example: Email

    Properties: Alphanumeric, size: 80

    Entered By: system

    Type of Key: primary

    Required: yes

  3. Value

Data type: Alphanumeric

Definition: the value of the variable

Example: user@host.com

Properties: Alphanumeric, size: 80

Entered By: system

Type of Key: primary

Required: yes

Table: upload_#
The table ‘upload_#’ is really another ‘Contact’ table provided to each registered Relatamail user for uploading new subscribers. The ‘#’ is replaced with the user’s ‘user number’ (eg. user number = 1, upload_1). The user’s upload table records information for each new subscriber that is to be uploaded to the ‘Contact’ table.
 

Field

Type

Null

Email

varchar(80)

No

First_Name

varchar(40)

No

Last_Name

varchar(40)

No

Address

varchar(60)

No

City

varchar(40)

No

State

varchar(20)

No

Zip

varchar(20)

No

Country

varchar(40)

No

Phone1

varchar(30)

No

Phone2

varchar(30)

No

Fax

varchar(30)

No

Language

varchar(30)

No

Birthdate

varchar(20)

No

Sex

char(1)

No

Married

char(1)

No

Employed

char(1)

No

Email_Type

char(1)

No

Entry_Date

date

No

Undeliverable_Count

int(11)

No

 

 

   

Keyname

Unique

Field

PRIMARY

Yes

Email

Email

No

Email

 Fields:

  1. Email
  2. Data Type: Alphanumeric

    Definition: the unique email address of the person. Each person has an unique email address that is uniquely theirs, it identifies them.

    Example: avinesh@stratabase.com

    Properties: alphanumeric, size: 80

    Entered By: user

    Type of Key: primary

    Required: yes 

  3. First_Name
  4. Data Type: Alphanumeric

    Definition: the first name of the person

    Example: Avinesh

    Properties: Alphanumeric, size: 40

    Entered By: user

    Type of Key: non-primary

    Required: no

  5. Last_Name
  6. Data Type: Alphanumeric

    Definition: the last name of the person

    Example: Bangar

    Properties: Alphanumeric, size: 40

    Entered By: user

    Type of Key: non-primary

    Required: no 

  7. Address
  8. Data Type: Alphanumeric

    Definition: the street address where the person lives

    Example: 12345 Any Street

    Properties: Alphanumeric, size: 60

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  9. City
  10. Data Type: Alphanumeric

    Definition: the city where the person lives

    Example: Abbotsford

    Properties: Alphanumeric, size: 40

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  11. State
  12. Data Type: Alphanumeric

    Definition: the state or province where the person lives

    Example: Avinesh

    Properties: Alphanumeric, size: 20

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  13. Zip
  14. Data Type: Alphanumeric

    Definition: the zip or postal code where the person lives first name of the person

    Example: 12345

    Properties: Alphanumeric, size: 20

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  15. Country
  16. Data Type: Alphanumeric

    Definition: the country where the person lives

    Example: CANADA

    Properties: Alphanumeric, size: 40

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  17. Phone1
  18. Data Type: Alphanumeric

    Definition: the primary phone number of the person

    Example: 123-4567

    Properties: Alphanumeric, size: 30

    Entered By: user

    Type of Key: non-primary

    Required: no

     

     

  19. Phone2
  20. Data Type: Alphanumeric

    Definition: the secondary phone number of the person

    Example: 123-4567

    Properties: Alphanumeric, size: 30

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  21. Fax
  22. Data Type: Alphanumeric

    Definition: the fax number of the person

    Example: 123-4567

    Properties: Alphanumeric, size: 30

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  23. Language
  24. Data Type: Alphanumeric

    Definition: the preferred language of the person

    Example: English

    Properties: Alphanumeric, size: 30

    Entered By: user

    Type of Key: non-primary

    Required: no

     

     

  25. Birthdate
  26. Data Type: Alphanumeric

    Definition: the birthdate of the person

    Example: 01-01-01

    Properties: Alphanumeric, size: 20

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  27. Sex
  28. Data Type: Alpha

    Definition: person is either male (M) or female (F)

    Example: M

    Properties: Alpha, size: 1

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  29. Married
  30. Data Type: Alpha

    Definition: person is either single (S) or married (M)

    Example: S

    Properties: Alpha, size: 1

    Entered By: user

    Type of Key: non-primary

    Required: no

     

     

  31. Employed
  32. Data Type: Alpha

    Definition: person is either employed (E) or unemployed (U) or retired (R)

    Example: E

    Properties: Alpha, size: 1

    Entered By: user

    Type of Key: non-primary

    Required: no

     

  33. Email_Type
  34. Data Type: Alpha

    Definition: the email type used by the person – either HTML or Text

    Example: H (H or T)

    Properties: Alpha, size: 1

    Entered By: system

    Type of Key: non-primary

    Required: no

     

  35. Entry_Date
  36. Data Type: Numeric (Date)

    Definition: the date the person was first entered into our database

    Example: MM/DD/YYYY

    Properties: Numeric, size: 10

    Entered By: system

    Type of Key: non-primary

    Required: no

     

     

  37. Undeliverable_Count

Data Type: Numeric

Definition: the number of times an undeliverable email was sent to this person

Example: 2

Properties: Numeric, size: 1

Entered By: system

Type of Key: non-primary

Required: no